package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.TbYmjg;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2024-12-11
 */
public interface TbYmjgMapper {

    @Select(" select PRICE,PRICE1 from tb_ymjg \n" +
            "where WERKS = #{WERKS} AND \n" +
            "ZCONTRACT = #{ZCONTRACT} AND \n" +
            "DATE1 != '0000-00-00'  AND \n" +
            "GETDATE() >= CAST(DATE2 AS DATETIME) + CAST(TIME2 AS DATETIME) AND \n" +
            "GETDATE() <= CAST(DATE1 AS DATETIME) + CAST(TIME1 AS DATETIME) ")
    public TbYmjg selectymjg(@Param("WERKS") String WERKS,@Param("ZCONTRACT")String ZCONTRACT);

}
